Overview
Brought to you by YData
Dataset statistics
| Number of variables | 18 |
|---|---|
| Number of observations | 73100 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 9.2 MiB |
| Average record size in memory | 132.0 B |
Variable types
| DateTime | 1 |
|---|---|
| Categorical | 9 |
| Numeric | 8 |
Competitor Pricing is highly overall correlated with Price | High correlation |
Demand Forecast is highly overall correlated with Inventory Level and 1 other fields | High correlation |
Inventory Level is highly overall correlated with Demand Forecast and 1 other fields | High correlation |
Price is highly overall correlated with Competitor Pricing | High correlation |
Units Sold is highly overall correlated with Demand Forecast and 1 other fields | High correlation |
Store ID is uniformly distributed | Uniform |
Product ID is uniformly distributed | Uniform |
Reproduction
| Analysis started | 2025-03-21 13:34:17.518166 |
|---|---|
| Analysis finished | 2025-03-21 13:34:22.953617 |
| Duration | 5.44 seconds |
| Software version | ydata-profiling vv4.15.1 |
| Download configuration | config.json |
Variables
Date
Date
| Distinct | 731 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 571.2 KiB |
| Minimum | 2022-01-01 00:00:00 |
|---|---|
| Maximum | 2024-01-01 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
Store ID
Categorical
Uniform
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 571.2 KiB |
| S001 | |
|---|---|
| S002 | |
| S003 | |
| S004 | |
| S005 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | S001 |
|---|---|
| 2nd row | S001 |
| 3rd row | S001 |
| 4th row | S001 |
| 5th row | S001 |
Common Values
| Value | Count | Frequency (%) |
| S001 | 14620 | |
| S002 | 14620 | |
| S003 | 14620 | |
| S004 | 14620 | |
| S005 | 14620 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| s001 | 14620 | |
| s002 | 14620 | |
| s003 | 14620 | |
| s004 | 14620 | |
| s005 | 14620 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 146200 | |
| S | 73100 | |
| 1 | 14620 | 5.0% |
| 2 | 14620 | 5.0% |
| 3 | 14620 | 5.0% |
| 4 | 14620 | 5.0% |
| 5 | 14620 | 5.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 292400 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 146200 | |
| S | 73100 | |
| 1 | 14620 | 5.0% |
| 2 | 14620 | 5.0% |
| 3 | 14620 | 5.0% |
| 4 | 14620 | 5.0% |
| 5 | 14620 | 5.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 292400 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 146200 | |
| S | 73100 | |
| 1 | 14620 | 5.0% |
| 2 | 14620 | 5.0% |
| 3 | 14620 | 5.0% |
| 4 | 14620 | 5.0% |
| 5 | 14620 | 5.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 292400 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 146200 | |
| S | 73100 | |
| 1 | 14620 | 5.0% |
| 2 | 14620 | 5.0% |
| 3 | 14620 | 5.0% |
| 4 | 14620 | 5.0% |
| 5 | 14620 | 5.0% |
Product ID
Categorical
Uniform
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 571.2 KiB |
| P0001 | 3655 |
|---|---|
| P0002 | 3655 |
| P0003 | 3655 |
| P0004 | 3655 |
| P0005 | 3655 |
| Other values (15) |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | P0001 |
|---|---|
| 2nd row | P0002 |
| 3rd row | P0003 |
| 4th row | P0004 |
| 5th row | P0005 |
Common Values
| Value | Count | Frequency (%) |
| P0001 | 3655 | 5.0% |
| P0002 | 3655 | 5.0% |
| P0003 | 3655 | 5.0% |
| P0004 | 3655 | 5.0% |
| P0005 | 3655 | 5.0% |
| P0006 | 3655 | 5.0% |
| P0007 | 3655 | 5.0% |
| P0008 | 3655 | 5.0% |
| P0009 | 3655 | 5.0% |
| P0010 | 3655 | 5.0% |
| Other values (10) | 36550 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| p0001 | 3655 | 5.0% |
| p0002 | 3655 | 5.0% |
| p0003 | 3655 | 5.0% |
| p0004 | 3655 | 5.0% |
| p0005 | 3655 | 5.0% |
| p0006 | 3655 | 5.0% |
| p0007 | 3655 | 5.0% |
| p0008 | 3655 | 5.0% |
| p0009 | 3655 | 5.0% |
| p0010 | 3655 | 5.0% |
| Other values (10) | 36550 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 186405 | |
| P | 73100 | 20.0% |
| 1 | 43860 | 12.0% |
| 2 | 10965 | 3.0% |
| 3 | 7310 | 2.0% |
| 4 | 7310 | 2.0% |
| 5 | 7310 | 2.0% |
| 6 | 7310 | 2.0% |
| 7 | 7310 | 2.0% |
| 8 | 7310 | 2.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 365500 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 186405 | |
| P | 73100 | 20.0% |
| 1 | 43860 | 12.0% |
| 2 | 10965 | 3.0% |
| 3 | 7310 | 2.0% |
| 4 | 7310 | 2.0% |
| 5 | 7310 | 2.0% |
| 6 | 7310 | 2.0% |
| 7 | 7310 | 2.0% |
| 8 | 7310 | 2.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 365500 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 186405 | |
| P | 73100 | 20.0% |
| 1 | 43860 | 12.0% |
| 2 | 10965 | 3.0% |
| 3 | 7310 | 2.0% |
| 4 | 7310 | 2.0% |
| 5 | 7310 | 2.0% |
| 6 | 7310 | 2.0% |
| 7 | 7310 | 2.0% |
| 8 | 7310 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 365500 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 186405 | |
| P | 73100 | 20.0% |
| 1 | 43860 | 12.0% |
| 2 | 10965 | 3.0% |
| 3 | 7310 | 2.0% |
| 4 | 7310 | 2.0% |
| 5 | 7310 | 2.0% |
| 6 | 7310 | 2.0% |
| 7 | 7310 | 2.0% |
| 8 | 7310 | 2.0% |
Category
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 571.2 KiB |
| Furniture | |
|---|---|
| Toys | |
| Clothing | |
| Groceries | |
| Electronics |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 8.1956361 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Groceries |
|---|---|
| 2nd row | Toys |
| 3rd row | Toys |
| 4th row | Toys |
| 5th row | Electronics |
Common Values
| Value | Count | Frequency (%) |
| Furniture | 14699 | |
| Toys | 14643 | |
| Clothing | 14626 | |
| Groceries | 14611 | |
| Electronics | 14521 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| furniture | 14699 | |
| toys | 14643 | |
| clothing | 14626 | |
| groceries | 14611 | |
| electronics | 14521 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 73141 | |
| i | 58457 | |
| e | 58442 | |
| o | 58401 | |
| t | 43846 | 7.3% |
| n | 43846 | 7.3% |
| s | 43775 | 7.3% |
| c | 43653 | 7.3% |
| u | 29398 | 4.9% |
| l | 29147 | 4.9% |
| Other values (8) | 116995 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 599101 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 73141 | |
| i | 58457 | |
| e | 58442 | |
| o | 58401 | |
| t | 43846 | 7.3% |
| n | 43846 | 7.3% |
| s | 43775 | 7.3% |
| c | 43653 | 7.3% |
| u | 29398 | 4.9% |
| l | 29147 | 4.9% |
| Other values (8) | 116995 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 599101 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 73141 | |
| i | 58457 | |
| e | 58442 | |
| o | 58401 | |
| t | 43846 | 7.3% |
| n | 43846 | 7.3% |
| s | 43775 | 7.3% |
| c | 43653 | 7.3% |
| u | 29398 | 4.9% |
| l | 29147 | 4.9% |
| Other values (8) | 116995 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 599101 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 73141 | |
| i | 58457 | |
| e | 58442 | |
| o | 58401 | |
| t | 43846 | 7.3% |
| n | 43846 | 7.3% |
| s | 43775 | 7.3% |
| c | 43653 | 7.3% |
| u | 29398 | 4.9% |
| l | 29147 | 4.9% |
| Other values (8) | 116995 |
Region
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 571.2 KiB |
| East | |
|---|---|
| South | |
| North | |
| West |
Length
| Max length | 5 |
|---|---|
| Median length | 4 |
| Mean length | 4.499658 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | North |
|---|---|
| 2nd row | South |
| 3rd row | West |
| 4th row | North |
| 5th row | East |
Common Values
| Value | Count | Frequency (%) |
| East | 18349 | |
| South | 18297 | |
| North | 18228 | |
| West | 18226 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| east | 18349 | |
| south | 18297 | |
| north | 18228 | |
| west | 18226 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 73100 | |
| s | 36575 | |
| h | 36525 | |
| o | 36525 | |
| E | 18349 | 5.6% |
| a | 18349 | 5.6% |
| S | 18297 | 5.6% |
| u | 18297 | 5.6% |
| N | 18228 | 5.5% |
| r | 18228 | 5.5% |
| Other values (2) | 36452 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 328925 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 73100 | |
| s | 36575 | |
| h | 36525 | |
| o | 36525 | |
| E | 18349 | 5.6% |
| a | 18349 | 5.6% |
| S | 18297 | 5.6% |
| u | 18297 | 5.6% |
| N | 18228 | 5.5% |
| r | 18228 | 5.5% |
| Other values (2) | 36452 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 328925 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 73100 | |
| s | 36575 | |
| h | 36525 | |
| o | 36525 | |
| E | 18349 | 5.6% |
| a | 18349 | 5.6% |
| S | 18297 | 5.6% |
| u | 18297 | 5.6% |
| N | 18228 | 5.5% |
| r | 18228 | 5.5% |
| Other values (2) | 36452 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 328925 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 73100 | |
| s | 36575 | |
| h | 36525 | |
| o | 36525 | |
| E | 18349 | 5.6% |
| a | 18349 | 5.6% |
| S | 18297 | 5.6% |
| u | 18297 | 5.6% |
| N | 18228 | 5.5% |
| r | 18228 | 5.5% |
| Other values (2) | 36452 |
Inventory Level
Real number (ℝ)
High correlation
| Distinct | 451 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 274.46988 |
| Minimum | 50 |
|---|---|
| Maximum | 500 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 571.2 KiB |
Quantile statistics
| Minimum | 50 |
|---|---|
| 5-th percentile | 72 |
| Q1 | 162 |
| median | 273 |
| Q3 | 387 |
| 95-th percentile | 478 |
| Maximum | 500 |
| Range | 450 |
| Interquartile range (IQR) | 225 |
Descriptive statistics
| Standard deviation | 129.94951 |
|---|---|
| Coefficient of variation (CV) | 0.47345638 |
| Kurtosis | -1.2001679 |
| Mean | 274.46988 |
| Median Absolute Deviation (MAD) | 112 |
| Skewness | 0.010115518 |
| Sum | 20063748 |
| Variance | 16886.876 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 168 | 203 | 0.3% |
| 486 | 199 | 0.3% |
| 302 | 195 | 0.3% |
| 429 | 194 | 0.3% |
| 201 | 194 | 0.3% |
| 410 | 191 | 0.3% |
| 71 | 191 | 0.3% |
| 159 | 190 | 0.3% |
| 288 | 190 | 0.3% |
| 119 | 189 | 0.3% |
| Other values (441) | 71164 |
| Value | Count | Frequency (%) |
| 50 | 130 | |
| 51 | 148 | |
| 52 | 153 | |
| 53 | 134 | |
| 54 | 165 | |
| 55 | 161 | |
| 56 | 152 | |
| 57 | 164 | |
| 58 | 173 | |
| 59 | 153 |
| Value | Count | Frequency (%) |
| 500 | 159 | |
| 499 | 164 | |
| 498 | 163 | |
| 497 | 133 | |
| 496 | 156 | |
| 495 | 171 | |
| 494 | 165 | |
| 493 | 151 | |
| 492 | 160 | |
| 491 | 141 |
Units Sold
Real number (ℝ)
High correlation
| Distinct | 498 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 136.46487 |
| Minimum | 0 |
|---|---|
| Maximum | 499 |
| Zeros | 360 |
| Zeros (%) | 0.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 571.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 49 |
| median | 107 |
| Q3 | 203 |
| 95-th percentile | 357 |
| Maximum | 499 |
| Range | 499 |
| Interquartile range (IQR) | 154 |
Descriptive statistics
| Standard deviation | 108.91941 |
|---|---|
| Coefficient of variation (CV) | 0.79814978 |
| Kurtosis | 0.053882636 |
| Mean | 136.46487 |
| Median Absolute Deviation (MAD) | 69 |
| Skewness | 0.90533263 |
| Sum | 9975582 |
| Variance | 11863.437 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 40 | 436 | 0.6% |
| 42 | 418 | 0.6% |
| 1 | 407 | 0.6% |
| 33 | 398 | 0.5% |
| 38 | 394 | 0.5% |
| 26 | 394 | 0.5% |
| 28 | 393 | 0.5% |
| 31 | 393 | 0.5% |
| 58 | 392 | 0.5% |
| 17 | 390 | 0.5% |
| Other values (488) | 69085 |
| Value | Count | Frequency (%) |
| 0 | 360 | |
| 1 | 407 | |
| 2 | 386 | |
| 3 | 369 | |
| 4 | 365 | |
| 5 | 359 | |
| 6 | 364 | |
| 7 | 369 | |
| 8 | 378 | |
| 9 | 331 |
| Value | Count | Frequency (%) |
| 499 | 1 | < 0.1% |
| 496 | 2 | < 0.1% |
| 495 | 1 | < 0.1% |
| 494 | 2 | < 0.1% |
| 493 | 1 | < 0.1% |
| 492 | 1 | < 0.1% |
| 491 | 3 | |
| 490 | 1 | < 0.1% |
| 489 | 2 | < 0.1% |
| 488 | 6 |
Units Ordered
Real number (ℝ)
| Distinct | 181 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 110.00447 |
| Minimum | 20 |
|---|---|
| Maximum | 200 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 571.2 KiB |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 29 |
| Q1 | 65 |
| median | 110 |
| Q3 | 155 |
| 95-th percentile | 191 |
| Maximum | 200 |
| Range | 180 |
| Interquartile range (IQR) | 90 |
Descriptive statistics
| Standard deviation | 52.277448 |
|---|---|
| Coefficient of variation (CV) | 0.4752302 |
| Kurtosis | -1.2023336 |
| Mean | 110.00447 |
| Median Absolute Deviation (MAD) | 45 |
| Skewness | 0.0037865171 |
| Sum | 8041327 |
| Variance | 2732.9316 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 56 | 463 | 0.6% |
| 43 | 462 | 0.6% |
| 68 | 458 | 0.6% |
| 71 | 453 | 0.6% |
| 138 | 448 | 0.6% |
| 75 | 446 | 0.6% |
| 83 | 445 | 0.6% |
| 105 | 444 | 0.6% |
| 173 | 440 | 0.6% |
| 189 | 437 | 0.6% |
| Other values (171) | 68604 |
| Value | Count | Frequency (%) |
| 20 | 398 | |
| 21 | 413 | |
| 22 | 430 | |
| 23 | 398 | |
| 24 | 367 | |
| 25 | 399 | |
| 26 | 412 | |
| 27 | 385 | |
| 28 | 393 | |
| 29 | 401 |
| Value | Count | Frequency (%) |
| 200 | 407 | |
| 199 | 422 | |
| 198 | 397 | |
| 197 | 394 | |
| 196 | 400 | |
| 195 | 387 | |
| 194 | 399 | |
| 193 | 417 | |
| 192 | 421 | |
| 191 | 377 |
Demand Forecast
Real number (ℝ)
High correlation
| Distinct | 31608 |
|---|---|
| Distinct (%) | 43.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 141.49472 |
| Minimum | -9.99 |
|---|---|
| Maximum | 518.55 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 673 |
| Negative (%) | 0.9% |
| Memory size | 571.2 KiB |
Quantile statistics
| Minimum | -9.99 |
|---|---|
| 5-th percentile | 13.85 |
| Q1 | 53.67 |
| median | 113.015 |
| Q3 | 208.0525 |
| 95-th percentile | 361.421 |
| Maximum | 518.55 |
| Range | 528.54 |
| Interquartile range (IQR) | 154.3825 |
Descriptive statistics
| Standard deviation | 109.25408 |
|---|---|
| Coefficient of variation (CV) | 0.77214243 |
| Kurtosis | 0.049345196 |
| Mean | 141.49472 |
| Median Absolute Deviation (MAD) | 69.705 |
| Skewness | 0.89485225 |
| Sum | 10343264 |
| Variance | 11936.453 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 46.06 | 12 | < 0.1% |
| 21.84 | 12 | < 0.1% |
| 17.33 | 11 | < 0.1% |
| 33.84 | 11 | < 0.1% |
| 43.83 | 11 | < 0.1% |
| 27.43 | 11 | < 0.1% |
| 23.35 | 11 | < 0.1% |
| 26.77 | 11 | < 0.1% |
| 38.86 | 11 | < 0.1% |
| 95.24 | 11 | < 0.1% |
| Other values (31598) | 72988 |
| Value | Count | Frequency (%) |
| -9.99 | 1 | |
| -9.97 | 1 | |
| -9.79 | 1 | |
| -9.67 | 1 | |
| -9.62 | 1 | |
| -9.58 | 1 | |
| -9.55 | 1 | |
| -9.47 | 1 | |
| -9.46 | 1 | |
| -9.29 | 1 |
| Value | Count | Frequency (%) |
| 518.55 | 1 | |
| 512.36 | 1 | |
| 506.37 | 2 | |
| 505.39 | 1 | |
| 504.76 | 1 | |
| 503.43 | 1 | |
| 503.12 | 1 | |
| 503.04 | 1 | |
| 502.98 | 1 | |
| 502.77 | 1 |
Price
Real number (ℝ)
High correlation
| Distinct | 8999 |
|---|---|
| Distinct (%) | 12.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 55.135108 |
| Minimum | 10 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 571.2 KiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 14.33 |
| Q1 | 32.65 |
| median | 55.05 |
| Q3 | 77.86 |
| 95-th percentile | 95.51 |
| Maximum | 100 |
| Range | 90 |
| Interquartile range (IQR) | 45.21 |
Descriptive statistics
| Standard deviation | 26.021945 |
|---|---|
| Coefficient of variation (CV) | 0.47196687 |
| Kurtosis | -1.1994896 |
| Mean | 55.135108 |
| Median Absolute Deviation (MAD) | 22.6 |
| Skewness | -0.0027322066 |
| Sum | 4030376.4 |
| Variance | 677.1416 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 31.2 | 22 | < 0.1% |
| 82.63 | 20 | < 0.1% |
| 70.51 | 20 | < 0.1% |
| 61.29 | 20 | < 0.1% |
| 11.7 | 20 | < 0.1% |
| 93.24 | 19 | < 0.1% |
| 12.6 | 19 | < 0.1% |
| 63.98 | 19 | < 0.1% |
| 64.49 | 19 | < 0.1% |
| 42.97 | 19 | < 0.1% |
| Other values (8989) | 72903 |
| Value | Count | Frequency (%) |
| 10 | 2 | < 0.1% |
| 10.01 | 17 | |
| 10.02 | 10 | |
| 10.03 | 6 | < 0.1% |
| 10.04 | 12 | |
| 10.05 | 6 | < 0.1% |
| 10.06 | 10 | |
| 10.07 | 12 | |
| 10.08 | 7 | |
| 10.09 | 11 |
| Value | Count | Frequency (%) |
| 100 | 1 | < 0.1% |
| 99.99 | 5 | |
| 99.98 | 6 | |
| 99.97 | 4 | |
| 99.96 | 7 | |
| 99.95 | 9 | |
| 99.94 | 5 | |
| 99.93 | 6 | |
| 99.92 | 6 | |
| 99.91 | 5 |
Discount
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 571.2 KiB |
| 20 | |
|---|---|
| 0 | |
| 15 | |
| 5 | |
| 10 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 1.5998222 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 20 |
|---|---|
| 2nd row | 20 |
| 3rd row | 10 |
| 4th row | 10 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 20 | 14715 | |
| 0 | 14662 | |
| 15 | 14624 | |
| 5 | 14591 | |
| 10 | 14508 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 20 | 14715 | |
| 0 | 14662 | |
| 15 | 14624 | |
| 5 | 14591 | |
| 10 | 14508 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 43885 | |
| 5 | 29215 | |
| 1 | 29132 | |
| 2 | 14715 | 12.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 116947 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 43885 | |
| 5 | 29215 | |
| 1 | 29132 | |
| 2 | 14715 | 12.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 116947 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 43885 | |
| 5 | 29215 | |
| 1 | 29132 | |
| 2 | 14715 | 12.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 116947 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 43885 | |
| 5 | 29215 | |
| 1 | 29132 | |
| 2 | 14715 | 12.6% |
Weather Condition
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 571.2 KiB |
| Sunny | |
|---|---|
| Rainy | |
| Snowy | |
| Cloudy |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 5.2497948 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Rainy |
|---|---|
| 2nd row | Sunny |
| 3rd row | Sunny |
| 4th row | Cloudy |
| 5th row | Sunny |
Common Values
| Value | Count | Frequency (%) |
| Sunny | 18290 | |
| Rainy | 18278 | |
| Snowy | 18272 | |
| Cloudy | 18260 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| sunny | 18290 | |
| rainy | 18278 | |
| snowy | 18272 | |
| cloudy | 18260 |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 73130 | |
| y | 73100 | |
| S | 36562 | |
| u | 36550 | |
| o | 36532 | |
| R | 18278 | 4.8% |
| a | 18278 | 4.8% |
| i | 18278 | 4.8% |
| w | 18272 | 4.8% |
| C | 18260 | 4.8% |
| Other values (2) | 36520 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 383760 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 73130 | |
| y | 73100 | |
| S | 36562 | |
| u | 36550 | |
| o | 36532 | |
| R | 18278 | 4.8% |
| a | 18278 | 4.8% |
| i | 18278 | 4.8% |
| w | 18272 | 4.8% |
| C | 18260 | 4.8% |
| Other values (2) | 36520 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 383760 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 73130 | |
| y | 73100 | |
| S | 36562 | |
| u | 36550 | |
| o | 36532 | |
| R | 18278 | 4.8% |
| a | 18278 | 4.8% |
| i | 18278 | 4.8% |
| w | 18272 | 4.8% |
| C | 18260 | 4.8% |
| Other values (2) | 36520 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 383760 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 73130 | |
| y | 73100 | |
| S | 36562 | |
| u | 36550 | |
| o | 36532 | |
| R | 18278 | 4.8% |
| a | 18278 | 4.8% |
| i | 18278 | 4.8% |
| w | 18272 | 4.8% |
| C | 18260 | 4.8% |
| Other values (2) | 36520 |
Holiday/Promotion
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 571.2 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 36747 | |
| 1 | 36353 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 36747 | |
| 1 | 36353 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 36747 | |
| 1 | 36353 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 73100 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 36747 | |
| 1 | 36353 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 73100 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 36747 | |
| 1 | 36353 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 73100 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 36747 | |
| 1 | 36353 |
Competitor Pricing
Real number (ℝ)
High correlation
| Distinct | 9751 |
|---|---|
| Distinct (%) | 13.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 55.146077 |
| Minimum | 5.03 |
|---|---|
| Maximum | 104.94 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 571.2 KiB |
Quantile statistics
| Minimum | 5.03 |
|---|---|
| 5-th percentile | 14.37 |
| Q1 | 32.68 |
| median | 55.01 |
| Q3 | 77.82 |
| 95-th percentile | 95.69 |
| Maximum | 104.94 |
| Range | 99.91 |
| Interquartile range (IQR) | 45.14 |
Descriptive statistics
| Standard deviation | 26.191408 |
|---|---|
| Coefficient of variation (CV) | 0.47494598 |
| Kurtosis | -1.1696703 |
| Mean | 55.146077 |
| Median Absolute Deviation (MAD) | 22.55 |
| Skewness | -0.0021660999 |
| Sum | 4031178.3 |
| Variance | 685.98985 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 37 | 21 | < 0.1% |
| 46.39 | 21 | < 0.1% |
| 42.19 | 19 | < 0.1% |
| 77.99 | 19 | < 0.1% |
| 64.66 | 18 | < 0.1% |
| 94.22 | 18 | < 0.1% |
| 16.65 | 18 | < 0.1% |
| 35.28 | 18 | < 0.1% |
| 19.98 | 18 | < 0.1% |
| 74.91 | 18 | < 0.1% |
| Other values (9741) | 72912 |
| Value | Count | Frequency (%) |
| 5.03 | 1 | |
| 5.29 | 1 | |
| 5.31 | 1 | |
| 5.34 | 2 | |
| 5.4 | 1 | |
| 5.44 | 1 | |
| 5.45 | 2 | |
| 5.46 | 1 | |
| 5.47 | 1 | |
| 5.49 | 1 |
| Value | Count | Frequency (%) |
| 104.94 | 1 | |
| 104.91 | 1 | |
| 104.81 | 1 | |
| 104.74 | 1 | |
| 104.64 | 1 | |
| 104.58 | 1 | |
| 104.57 | 2 | |
| 104.56 | 1 | |
| 104.55 | 1 | |
| 104.48 | 1 |
Seasonality
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 571.2 KiB |
| Spring | |
|---|---|
| Summer | |
| Winter | |
| Autumn |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Autumn |
|---|---|
| 2nd row | Autumn |
| 3rd row | Summer |
| 4th row | Autumn |
| 5th row | Summer |
Common Values
| Value | Count | Frequency (%) |
| Spring | 18317 | |
| Summer | 18305 | |
| Winter | 18285 | |
| Autumn | 18193 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| spring | 18317 | |
| summer | 18305 | |
| winter | 18285 | |
| autumn | 18193 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 54907 | |
| m | 54803 | |
| n | 54795 | |
| u | 54691 | |
| S | 36622 | |
| i | 36602 | |
| e | 36590 | |
| t | 36478 | |
| p | 18317 | 4.2% |
| g | 18317 | 4.2% |
| Other values (2) | 36478 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 438600 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 54907 | |
| m | 54803 | |
| n | 54795 | |
| u | 54691 | |
| S | 36622 | |
| i | 36602 | |
| e | 36590 | |
| t | 36478 | |
| p | 18317 | 4.2% |
| g | 18317 | 4.2% |
| Other values (2) | 36478 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 438600 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 54907 | |
| m | 54803 | |
| n | 54795 | |
| u | 54691 | |
| S | 36622 | |
| i | 36602 | |
| e | 36590 | |
| t | 36478 | |
| p | 18317 | 4.2% |
| g | 18317 | 4.2% |
| Other values (2) | 36478 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 438600 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 54907 | |
| m | 54803 | |
| n | 54795 | |
| u | 54691 | |
| S | 36622 | |
| i | 36602 | |
| e | 36590 | |
| t | 36478 | |
| p | 18317 | 4.2% |
| g | 18317 | 4.2% |
| Other values (2) | 36478 |
Year
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 571.2 KiB |
| 2022 | |
|---|---|
| 2023 | |
| 2024 | 100 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2022 |
|---|---|
| 2nd row | 2022 |
| 3rd row | 2022 |
| 4th row | 2022 |
| 5th row | 2022 |
Common Values
| Value | Count | Frequency (%) |
| 2022 | 36500 | |
| 2023 | 36500 | |
| 2024 | 100 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2022 | 36500 | |
| 2023 | 36500 | |
| 2024 | 100 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 182700 | |
| 0 | 73100 | |
| 3 | 36500 | 12.5% |
| 4 | 100 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 292400 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 182700 | |
| 0 | 73100 | |
| 3 | 36500 | 12.5% |
| 4 | 100 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 292400 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 182700 | |
| 0 | 73100 | |
| 3 | 36500 | 12.5% |
| 4 | 100 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 292400 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 182700 | |
| 0 | 73100 | |
| 3 | 36500 | 12.5% |
| 4 | 100 | < 0.1% |
Month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.5184679 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 285.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.4515644 |
|---|---|
| Coefficient of variation (CV) | 0.52950547 |
| Kurtosis | -1.2082718 |
| Mean | 6.5184679 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.0094523839 |
| Sum | 476500 |
| Variance | 11.913297 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 1 | 6300 | |
| 3 | 6200 | |
| 7 | 6200 | |
| 5 | 6200 | |
| 12 | 6200 | |
| 10 | 6200 | |
| 8 | 6200 | |
| 4 | 6000 | |
| 9 | 6000 | |
| 6 | 6000 | |
| Other values (2) | 11600 |
| Value | Count | Frequency (%) |
| 1 | 6300 | |
| 2 | 5600 | |
| 3 | 6200 | |
| 4 | 6000 | |
| 5 | 6200 | |
| 6 | 6000 | |
| 7 | 6200 | |
| 8 | 6200 | |
| 9 | 6000 | |
| 10 | 6200 |
| Value | Count | Frequency (%) |
| 12 | 6200 | |
| 11 | 6000 | |
| 10 | 6200 | |
| 9 | 6000 | |
| 8 | 6200 | |
| 7 | 6200 | |
| 6 | 6000 | |
| 5 | 6200 | |
| 4 | 6000 | |
| 3 | 6200 |
Day
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.70041 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 285.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.8071111 |
|---|---|
| Coefficient of variation (CV) | 0.56094783 |
| Kurtosis | -1.1937451 |
| Mean | 15.70041 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.0079550329 |
| Sum | 1147700 |
| Variance | 77.565206 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) |
| 1 | 2500 | 3.4% |
| 2 | 2400 | 3.3% |
| 3 | 2400 | 3.3% |
| 4 | 2400 | 3.3% |
| 5 | 2400 | 3.3% |
| 6 | 2400 | 3.3% |
| 7 | 2400 | 3.3% |
| 8 | 2400 | 3.3% |
| 9 | 2400 | 3.3% |
| 10 | 2400 | 3.3% |
| Other values (21) | 49000 |
| Value | Count | Frequency (%) |
| 1 | 2500 | |
| 2 | 2400 | |
| 3 | 2400 | |
| 4 | 2400 | |
| 5 | 2400 | |
| 6 | 2400 | |
| 7 | 2400 | |
| 8 | 2400 | |
| 9 | 2400 | |
| 10 | 2400 |
| Value | Count | Frequency (%) |
| 31 | 1400 | |
| 30 | 2200 | |
| 29 | 2200 | |
| 28 | 2400 | |
| 27 | 2400 | |
| 26 | 2400 | |
| 25 | 2400 | |
| 24 | 2400 | |
| 23 | 2400 | |
| 22 | 2400 |
Interactions
Correlations
| Category | Competitor Pricing | Day | Demand Forecast | Discount | Holiday/Promotion | Inventory Level | Month | Price | Product ID | Region | Seasonality | Store ID | Units Ordered | Units Sold | Weather Condition | Year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Category | 1.000 | 0.000 | 0.003 | 0.008 | 0.005 | 0.000 | 0.002 | 0.006 | 0.000 | 0.004 | 0.005 | 0.000 | 0.000 | 0.000 | 0.004 | 0.002 | 0.000 |
| Competitor Pricing | 0.000 | 1.000 | -0.000 | -0.000 | 0.002 | 0.000 | 0.009 | -0.009 | 0.994 | 0.004 | 0.005 | 0.009 | 0.000 | 0.005 | 0.000 | 0.000 | 0.000 |
| Day | 0.003 | -0.000 | 1.000 | 0.006 | 0.000 | 0.007 | 0.002 | 0.015 | -0.000 | 0.000 | 0.000 | 0.006 | 0.000 | -0.001 | 0.006 | 0.004 | 0.066 |
| Demand Forecast | 0.008 | -0.000 | 0.006 | 1.000 | 0.000 | 0.000 | 0.567 | 0.000 | -0.000 | 0.000 | 0.000 | 0.004 | 0.000 | -0.001 | 0.994 | 0.007 | 0.000 |
| Discount | 0.005 | 0.002 | 0.000 | 0.000 | 1.000 | 0.006 | 0.000 | 0.004 | 0.000 | 0.006 | 0.000 | 0.002 | 0.004 | 0.000 | 0.000 | 0.008 | 0.005 |
| Holiday/Promotion | 0.000 | 0.000 | 0.007 | 0.000 | 0.006 | 1.000 | 0.000 | 0.013 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.006 | 0.000 | 0.000 | 0.000 |
| Inventory Level | 0.002 | 0.009 | 0.002 | 0.567 | 0.000 | 0.000 | 1.000 | 0.002 | 0.009 | 0.000 | 0.000 | 0.004 | 0.008 | 0.001 | 0.568 | 0.000 | 0.006 |
| Month | 0.006 | -0.009 | 0.015 | 0.000 | 0.004 | 0.013 | 0.002 | 1.000 | -0.008 | 0.000 | 0.002 | 0.007 | 0.000 | -0.005 | 0.000 | 0.000 | 0.058 |
| Price | 0.000 | 0.994 | -0.000 | -0.000 | 0.000 | 0.000 | 0.009 | -0.008 | 1.000 | 0.000 | 0.010 | 0.005 | 0.000 | 0.004 | 0.000 | 0.000 | 0.000 |
| Product ID | 0.004 | 0.004 | 0.000 | 0.000 | 0.006 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.004 | 0.000 | 0.005 | 0.000 | 0.004 | 0.000 |
| Region | 0.005 | 0.005 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.002 | 0.010 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.003 |
| Seasonality | 0.000 | 0.009 | 0.006 | 0.004 | 0.002 | 0.000 | 0.004 | 0.007 | 0.005 | 0.004 | 0.000 | 1.000 | 0.000 | 0.000 | 0.003 | 0.002 | 0.003 |
| Store ID | 0.000 | 0.000 | 0.000 | 0.000 | 0.004 | 0.000 | 0.008 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| Units Ordered | 0.000 | 0.005 | -0.001 | -0.001 | 0.000 | 0.006 | 0.001 | -0.005 | 0.004 | 0.005 | 0.000 | 0.000 | 0.000 | 1.000 | -0.001 | 0.000 | 0.000 |
| Units Sold | 0.004 | 0.000 | 0.006 | 0.994 | 0.000 | 0.000 | 0.568 | 0.000 | 0.000 | 0.000 | 0.000 | 0.003 | 0.000 | -0.001 | 1.000 | 0.009 | 0.000 |
| Weather Condition | 0.002 | 0.000 | 0.004 | 0.007 | 0.008 | 0.000 | 0.000 | 0.000 | 0.000 | 0.004 | 0.000 | 0.002 | 0.000 | 0.000 | 0.009 | 1.000 | 0.000 |
| Year | 0.000 | 0.000 | 0.066 | 0.000 | 0.005 | 0.000 | 0.006 | 0.058 | 0.000 | 0.000 | 0.003 | 0.003 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| Date | Store ID | Product ID | Category | Region | Inventory Level | Units Sold | Units Ordered | Demand Forecast | Price | Discount | Weather Condition | Holiday/Promotion | Competitor Pricing | Seasonality | Year | Month | Day | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2022-01-01 | S001 | P0001 | Groceries | North | 231 | 127 | 55 | 135.47 | 33.50 | 20 | Rainy | 0 | 29.69 | Autumn | 2022 | 1 | 1 |
| 1 | 2022-01-01 | S001 | P0002 | Toys | South | 204 | 150 | 66 | 144.04 | 63.01 | 20 | Sunny | 0 | 66.16 | Autumn | 2022 | 1 | 1 |
| 2 | 2022-01-01 | S001 | P0003 | Toys | West | 102 | 65 | 51 | 74.02 | 27.99 | 10 | Sunny | 1 | 31.32 | Summer | 2022 | 1 | 1 |
| 3 | 2022-01-01 | S001 | P0004 | Toys | North | 469 | 61 | 164 | 62.18 | 32.72 | 10 | Cloudy | 1 | 34.74 | Autumn | 2022 | 1 | 1 |
| 4 | 2022-01-01 | S001 | P0005 | Electronics | East | 166 | 14 | 135 | 9.26 | 73.64 | 0 | Sunny | 0 | 68.95 | Summer | 2022 | 1 | 1 |
| 5 | 2022-01-01 | S001 | P0006 | Groceries | South | 138 | 128 | 102 | 139.82 | 76.83 | 10 | Sunny | 1 | 79.35 | Winter | 2022 | 1 | 1 |
| 6 | 2022-01-01 | S001 | P0007 | Furniture | East | 359 | 97 | 167 | 108.92 | 34.16 | 10 | Rainy | 1 | 36.55 | Winter | 2022 | 1 | 1 |
| 7 | 2022-01-01 | S001 | P0008 | Clothing | North | 380 | 312 | 54 | 329.73 | 97.99 | 5 | Cloudy | 0 | 100.09 | Spring | 2022 | 1 | 1 |
| 8 | 2022-01-01 | S001 | P0009 | Electronics | West | 183 | 175 | 135 | 174.15 | 20.74 | 10 | Cloudy | 0 | 17.66 | Autumn | 2022 | 1 | 1 |
| 9 | 2022-01-01 | S001 | P0010 | Toys | South | 108 | 28 | 196 | 24.47 | 59.99 | 0 | Rainy | 1 | 61.21 | Winter | 2022 | 1 | 1 |
| Date | Store ID | Product ID | Category | Region | Inventory Level | Units Sold | Units Ordered | Demand Forecast | Price | Discount | Weather Condition | Holiday/Promotion | Competitor Pricing | Seasonality | Year | Month | Day | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 73090 | 2024-01-01 | S005 | P0011 | Groceries | North | 156 | 121 | 156 | 137.12 | 86.09 | 0 | Snowy | 1 | 87.83 | Summer | 2024 | 1 | 1 |
| 73091 | 2024-01-01 | S005 | P0012 | Electronics | North | 495 | 324 | 42 | 317.46 | 36.94 | 10 | Sunny | 0 | 38.90 | Winter | 2024 | 1 | 1 |
| 73092 | 2024-01-01 | S005 | P0013 | Electronics | West | 389 | 276 | 99 | 277.27 | 32.05 | 0 | Snowy | 0 | 35.90 | Summer | 2024 | 1 | 1 |
| 73093 | 2024-01-01 | S005 | P0014 | Toys | West | 328 | 190 | 43 | 183.97 | 66.50 | 0 | Snowy | 1 | 65.12 | Winter | 2024 | 1 | 1 |
| 73094 | 2024-01-01 | S005 | P0015 | Furniture | North | 408 | 323 | 92 | 336.64 | 83.26 | 0 | Sunny | 0 | 80.96 | Winter | 2024 | 1 | 1 |
| 73095 | 2024-01-01 | S005 | P0016 | Furniture | East | 96 | 8 | 127 | 18.46 | 73.73 | 20 | Snowy | 0 | 72.45 | Winter | 2024 | 1 | 1 |
| 73096 | 2024-01-01 | S005 | P0017 | Toys | North | 313 | 51 | 101 | 48.43 | 82.57 | 10 | Cloudy | 0 | 83.78 | Autumn | 2024 | 1 | 1 |
| 73097 | 2024-01-01 | S005 | P0018 | Clothing | West | 278 | 36 | 151 | 39.65 | 11.11 | 10 | Rainy | 0 | 10.91 | Winter | 2024 | 1 | 1 |
| 73098 | 2024-01-01 | S005 | P0019 | Toys | East | 374 | 264 | 21 | 270.52 | 53.14 | 20 | Rainy | 0 | 55.80 | Spring | 2024 | 1 | 1 |
| 73099 | 2024-01-01 | S005 | P0020 | Groceries | East | 117 | 6 | 165 | 2.33 | 78.39 | 20 | Rainy | 1 | 79.52 | Spring | 2024 | 1 | 1 |